/**
 * Copyright (c) 2013-2022, Alibaba Group Holding Limited;
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * <p>
 * http://www.apache.org/licenses/LICENSE-2.0
 * </p>
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.aliyun.polardbx.binlog.canal.core.ddl.tsdb;

import org.junit.Test;

public class MemoryTableMetaTest_Function extends MemoryTableMetaBase {

    @Test
    public void testCreateFunction() {
        MemoryTableMeta memoryTableMeta = newMemoryTableMeta();
        String sql = "create function fac(n int unsigned) returns bigint unsigned\n"
            + "begin\n"
            + "declare f bigint unsigned default 1;\n"
            + "\n"
            + "while n > 1 do\n"
            + "set f = f * n;\n"
            + "set n = n - 1;\n"
            + "end while;\n"
            + "return f;\n"
            + "end";
        memoryTableMeta.apply(null, "d1", sql, null);
    }
}
